package com.hooya.fa.eu.biz.dao.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hooya.fa.eu.biz.dao.entity.Xsjl2303;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lzw
 * @since 2025-09-11
 */
@Mapper
public interface Xsjl2303Mapper extends BaseMapper<Xsjl2303> {

    @Select("SELECT DISTINCT dianpu AS store FROM rxh_europe.xsjl_2303")
    List<String> getStores();


    @Select("SELECT DISTINCT UPPER(orderid) AS orderid FROM rxh_europe.xsjl_2303 WHERE dianpu='oeu'")
    List<String> getOeuIds();

    List<String> selectSkuList(@Param("startDate") String startDate, @Param("endDate") String endDate);
}
